package webbrow.member.model;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.orm.ibatis.SqlMapClientTemplate;

public interface MemberDao {
	public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate);
	public int selectCountById(String id) throws SQLException;
	public int selectCountByEmail(MemberVO mvo) throws SQLException; 
	//String 에서 MemberVO 로 변경. 회원정보수정 페이지에서 
	public void insertMember(MemberVO vo)throws SQLException ;
	public MemberVO selectMemberByLogin(MemberVO mvo) throws SQLException;
	public MemberVO selectMemberByUpdate(MemberVO vo);
	public MemberVO selectMyInfo(String id)throws SQLException;
	public MemberVO selectMemberInfo(MemberVO vo);
	public void updateMember(MemberVO vo) throws SQLException;
	public int updateDropout(String id) throws SQLException;
	public List<MemberVO> selectMemberAll() throws SQLException;
	public int selectCountByEmailReg(String email) throws SQLException;
	public String selectPasswordByUserInfo(HashMap map) throws SQLException;
	public int selectDropout(String id) throws SQLException;
}
